SyCampus 
Logical Entity Name  SyCampus 
Default Table Name  SyCampus 
Physical Only  NO 
Definition 
 
Note 
 

SyCampus Columns 
ColumnName  Domain  Datatype  NULL  Definition 
Code    char(8)  NO 
 
Descrip    varchar(50)  NO 
 
Addr1    varchar(255)  YES 
 
Addr2    varchar(35)  YES 
 
City    char(25)  YES 
 
State    char(2)  YES 
 
Zip    char(10)  YES 
 
Phone1    varchar(16)  YES 
 
Phone2    varchar(16)  YES 
 
Phone3    varchar(16)  YES 
 
FaxNo    varchar(16)  YES 
 
email    varchar(50)  YES 
 
url    varchar(50)  YES 
 
domainname    varchar(50)  YES 
 
PellID    char(6)  YES 
 
RptRFMSPellID    char(6)  YES 
 
AttRFMSPellID    char(6)  YES 
 
DloanID    char(6)  YES 
 
PellIdBranch    char(2)  YES 
 
DefAcademicCalendar    char(1)  YES 
 
DefPaymentMethodology    char(1)  YES 
 
DefNumPaymentPeriods    char(1)  YES 
 
DefWeeksInAcademicYr    int  YES 
 
DefCredHourInAcadYr    int  YES 
 
TGNumber    char(7)  YES 
 
EDEPath    varchar(255)  YES 
 
MinTransDate    datetime  YES 
 
LastEarnDate    datetime  YES 
 
DefaultARAccount    nvarchar(100)  YES 
 
GLCompanyNumber    char(8)  YES 
 
GLSystem    char(8)  YES 
 
GLLastDateRel    datetime  YES 
 
Active    bit  NO 
 
ModFlag    char(1)  NO 
 
Userid    int  NO 
 
DateAdded    datetime  NO 
 
DateLstMod    datetime  NO 
 
ts    timestamp  NO 
 
UseClearingHouse    bit  NO 
 
ClearinghouseRptFlag    char(1)  YES 
 
ClearingHouseWDDateFlag    char(1)  YES 
 
SyCampusID(PK)    int  NO 
 
TIN    char(9)  YES 
 
TCC    char(5)  YES 
 
AllowAccounting    bit  NO 
 
AllowEnrollments    bit  NO 
 
AllowLeads    bit  NO 
 
ArAcctIndex    int  YES 
 
CancelDays    int  NO 
 
ClassScheduleComment    text  YES 
 
DurationLOA    int  NO 
 
GreatPlainsPath    char(256)  YES 
 
RetakeGpaCalc    tinyint  NO 
 
ServicerLastExtract    datetime  YES 
 
ServicerLink    char(1)  YES 
 
ServicerSchoolNumber    char(10)  YES 
 
TimeBetweenLOA    int  NO 
 
TimesAllowedLOA    int  NO 
 
GPBatchID    char(40)  YES 
 
GreatPlainsDynPath    char(256)  YES 
 
SerialNumber    char(6)  YES 
 
FirstCollegeChoice    char(6)  YES 
 
FloatingTerm    bit  NO 
 
ReportServerPath    varchar(500)  YES 
 
IncludeT4InStandard    bit  NO 
 
SyCountryID    int  YES 
 
T4AllowEdit    bit  NO 
 
T4Earn100    bit  NO 
 
UseTitleIVCalc    bit  NO 
 
OfficialSchoolName    varchar(120)  YES 
 
AllowNDSEnrollments    bit  NO 
 
CurrencySymbol    char(10)  NO 
 
CurrencySymbolPosition    tinyint  NO 
 
DefaultActiveStatus    int  NO 
 
DefaultNDSActiveStatus    int  NO 
 
FAFSAExtractOption    char(1)  NO 
 
LabelRptName    char(35)  YES 
 
QTDefaultSaBillCodeID    int  YES 
 
QTImportReview    bit  YES 
 
QuickTouchDSN    varchar(128)  YES 
 
UseLabelRpt    bit  YES 
 
StatusChangeDays    int  NO 
 
ServicerSchoolCode    char(8)  YES 
 
ServicerUserID    int  YES 
 
servicerpreventT4    bit  YES 
 
FAPackStatusPromoID    int  YES 
 
ServicerExportPath    varchar(255)  YES 
 
ServicerFASyStaffID    int  YES 
 
ServicerReqTerm    bit  NO 
 
ServicerSASyStaffID    int  YES 
 
SetTermStart    bit  NO 
 
FAAdminSyStaffID    int  YES 
 
AllowMakeUpHours    bit  NO 
 
OnlinePaymentAllow    bit  YES 
 
SyPaymentAccountID(FK)    int  YES 
 
OnlinePaymentUserID(FK)    int  YES 
 
TransMoveDateBilled    char(1)  NO 
 
TransMoveStartDate    char(1)  NO 
 
TransMoveLDA    char(1)  NO 
 
TransMoveCourses    char(1)  NO 
 
TransPerformDocReview    char(1)  NO 
 
TransModifyFees    char(1)  NO 
 
TransFaCmTemplateID(FK)    int  YES 
 
TransFaStaffDef    char(1)  NO 
 
TransFaSyStaffID(FK)    int  YES 
 
TransSaCmTemplateID(FK)    int  YES 
 
TransSaSyStaffID(FK)    int  YES 
 
TransSaStaffDef    char(1)  NO 
 
TransAllowQueue    bit  NO 
 
TransQueueProcessDate    char(1)  NO 
 
SetReentryToActive    bit  NO 
 
RegSumStuAddress    bit  YES 
 
RegSumIDToPrint    char(1)  YES 
 
RegSumStudentBal    bit  YES 
 
RegSumEnrollInfo    bit  YES 
 
RegSumPrintSched    bit  YES 
 
RegSumPrintDueDate    bit  YES 
 
RegSumDueDate    datetime  YES 
 
RegSumAddDrop    bit  YES 
 
RegSumExpFunding    char(1)  YES 
 
RegSumExpFundingTerm    int  YES 
 
RegSumEstimated    bit  YES 
 
RegSumPending    bit  YES 
 
RegSumApproved    bit  YES 
 
RegSumRegComment    varchar(500)  YES 
 
RegSumStuComment    varchar(500)  YES 
 
T4CreditBalanceDocID    int  YES 
 
RegBillEnrollCampus    bit  NO 
 
EnableNIStudent    bit  NO 
 
EnableSEVIS    bit  NO 
 
DefaultStudentGroupDays    numeric(3, 0)  YES 
 
AutoDisbApprov    bit  NO 
 
AutoRefundApprov    bit  NO 
 
AutoRefundDaysToDueDate    int  NO 
 
MoveEstimates    bit  NO 
 
MoveFA    char(1)  NO 
 
MoveBudget    char(1)  NO 
 
RptEntityID    char(8)  YES 
 
ATTEntityID    char(8)  YES 
 
AddDrop    char(1)  NO 
 
AddDropDays    smallint  NO 
 
AutomateRefund    bit  NO 
 
CreditCardDataRequired    bit  NO 
 
ISIRImportMatchMethod    char(1)  NO 
 
ISIRCGroupID(FK)    int  YES 
 
ISIRVerGroupID(FK)    int  YES 
 
T4Refund30DayExemptOverride    bit  NO 
 
ImageNowPath    varchar(255)  YES 
 
DownloadableDocumentsPath    varchar(1000)  YES 
 
SaGLExportFileDefinitionID(FK)    int  YES 
 
SAGLExportFilePath    varchar(255)  YES 
 
AutoGradeLevelPromotion    bit  NO 
 
VerifyInternalCreditCards    bit  NO 
 
SyQuickLeadTemplateID(FK)    int  YES 
 
AttendancePolicy    varchar(1000)  YES 
 
AllowWaitListing    bit  NO 
 
WaitListNotificationMode    char(16)  NO 
 
MaxWaitlistTermCredits    int  NO 
 
WaitlistMaxNumOfSeats    int  NO 
 
WaitlistMaxNumOfSeatsType    char(16)  NO 
 
PriorityResolution    char(16)  NO 
 
WaitListExpirationDays    int  NO 
 
WaitListExpirationType    char(16)  NO 
 
ReservationNotificationHours    int  NO 
 
AllowReservations    bit  NO 
 
MaxReservationTermCredits    int  NO 
 
ReservationExpMins    int  NO 
 
ReservationOnlineRegConfirmMins    int  NO 
 
AllowOnlineRegistration    bit  NO 
 
WaitlistNotifStudClearCmTemplateId    int  YES 
 
WaitlistNotifStudOfferedCmTemplateId    int  YES 
 
WaitlistNotifStudAcceptedCmTemplateId    int  YES 
 
C2KEmailClient    bit  NO 
 
ReqGrade4DropCourse    bit  NO 
 
FFELID    char(6)  YES 
 
FFELIDBranch    char(2)  YES 
 
ImageNowDBConnectString    varchar(255)  YES 
 
CnReportRandomKey    varchar(258)  YES 
 
OverrideNotReq4Status    int  NO 
 
AutoDisbPost    bit  NO 
 
UseCashiering    bit  NO 
 
LimitPackageToCOA    bit  NO 
 
PreventFundsWhenNoISIR    bit  NO 
 
PreventFundsWhenZeroCOA    bit  NO 
 
DLRptEntityID    char(8)  YES 
 
DLAttEntityID    char(8)  YES 
 
CashieringTimeout    int  YES 
 
DupCriteriaStatus    varchar(128)  YES 
 
DupSyCampusGrpID    int  YES 
 
DupCmTemplateID    int  YES 
 
SyDupCriteriaID    int  YES 
 
DupAutoProcess    bit  NO 
 
UsePortal    bit  NO 
 
EvaluateAnticipatedGradeLevelPromotion    bit  NO 
 
GradeLevelPromotionCmTemplateID    int  YES 
 
T4CreditBalanceDocIDParent    int  YES 
 
T4InstChargesDocIDParent    int  YES 
 
T4InstChargesDocIDStudent    int  YES 
 
CampusLinkAmbassadorUse    bit  NO 
 
CampusLinkAmbassadorStudentSpendingLimit    decimal(9, 2)  NO 
 
RegSumLedgerCard    bit  YES 
 
UpdateLDAwithMakeUpDate    bit  NO 
 
DefaultEmployerGroupDays    numeric(3, 0)  YES 
 
FaRestrictReadytoSend    bit  NO 
 
SaRefundPolicyID(FK)    int  YES 
 
GlobalExceptionSecurity    bit  NO 
 
CrmIntegrated    bit  NO 
 
FaPackStatusPromoTolerance    money  YES 
 
RetainLDA    bit  NO 
 
AwardWithREFC    bit  NO 
 
AllowDisbBatchPostWithException    bit  NO 
 
OrigCertEstAward    bit  NO 
 
AllowDisbursementWithInSameMonth    bit  NO 
 
AllowChangeForCanceledDisbursements    bit  NO 
 
AddDropCalendarDays    bit  NO 
 
CrmStudentEntryOverride    bit  NO 
 
CrmSuppressFlag    bit  NO 
 
regsumSubsidiary    bit  YES 
 
ApplyPaymentsMethod    char(1)  NO 
 
PPChargesDocIDStudent    int  YES 
 
PPChargesDocIDParent    int  YES 
 
OPEID    varchar(8)  YES 
 
GreatPlainsDynPathIV    varchar(100)  YES 
 
GreatPlainsPathIV    varchar(100)  YES 
 
TSMStudentGroupID(FK)    int  YES 
 
TSMHoldGroupID(FK)    int  YES 
 
AllowTransactionDueDate    char(10)  NO 
 
AllowCreditSourceOrder    char(10)  NO 
 
AllowApplyCreditAudit    char(10)  NO 
 
AllowAcademicYearLoanPackaging    char(10)  NO 
 
ApplyCreditEffectiveDate    char(10)  NO 
 
ACHOnlinePaymentAllow    char(10)  NO 
 
VerifyInternalACH    char(10)  NO 
 
SaACHPaymentAccountID(FK)    char(10)  YES 
 
OnlinePaymentACHUserID    char(10)  YES 
 
WaitlistNotificationStudentMovedToFutureReserveCmTemplateId    char(10)  YES 
 
CancelClassSectionNotificationToStaffCmTemplateId    char(10)  YES 
 
CancelClassSectionNotificationToStudentCmTemplateId    char(10)  YES 
 

SyCampus Primary and Unique Keys 
Key Name  Key Type  Keys 
SyCampus_SyCampusId_Code_U_N_IDX  Index  SyCampusID, Code 
SyCampus_SyCampusID_U_C_IDX  PrimaryKey  SyCampusID 

SyCampus Foreign Keys 
Parent Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype  Not For Replication 
SyGroups  Non-Identifying  Zero or One to Zero or More  FK_SyCampus_ISIRCGroupID_SyGroups_SyGroupsID      ISIRCGroupID  NO  YES 
SyGroups  Non-Identifying  Zero or One to Zero or More  FK_SyCampus_ISIRVerGroupID_SyGroups_SyGroupsID      ISIRVerGroupID  NO  YES 
SyStaff  Non-Identifying  Zero or One to Zero or More  FK_SyCampus_OnlinePaymentUserID_SyStaff_SyStaffID      OnlinePaymentUserID  NO  YES 
SaACHPaymentAccount  Non-Identifying  Zero or One to Zero or More  FK_SyCampus_SaACHPaymentAccountId_SaACHPaymentAccount_SaACHPaymentAccountId      SaACHPaymentAccountID  NO  YES 
SaGlExportFileDefinition  Non-Identifying  Zero or One to Zero or More  FK_SyCampus_SaGLExportFileDefinitionID_SaGLExportFileDefinition_SaGLExportFileDefinitionID      SaGLExportFileDefinitionID  NO  YES 
SaRefundPolicy  Non-Identifying  Zero or One to Zero or More  FK_SyCampus_SaRefundPolicyID_SaRefundPolicy_SaRefundPolicyID      SaRefundPolicyID  NO  YES 
SyPaymentAccount  Non-Identifying  Zero or One to Zero or More  FK_SyCampus_SyPaymentAccountID_SyPaymentAccount_SyPaymentAccountID      SyPaymentAccountID  NO  YES 
SyQuickLeadTemplate  Non-Identifying  Zero or One to Zero or More  FK_SyCampus_SyQuickLeadTemplateID_SyQuickLeadTemplate_SyQuickLeadTemplateID      SyQuickLeadTemplateID  NO  YES 
CmTemplate  Non-Identifying  Zero or One to Zero or More  FK_SyCampus_TransFaCmTemplateID_CmTemplate_CmTemplateID      TransFaCmTemplateID  NO  YES 
SyStaff  Non-Identifying  Zero or One to Zero or More  FK_SyCampus_TransFaSyStaffID_SyStaff_SyStaffID      TransFaSyStaffID  NO  YES 
CmTemplate  Non-Identifying  Zero or One to Zero or More  FK_SyCampus_TransSaCmTemplateID_CmTemplate_CmTemplateID      TransSaCmTemplateID  NO  YES 
SyStaff  Non-Identifying  Zero or One to Zero or More  FK_SyCampus_TransSaSyStaffID_SyStaff_SyStaffID      TransSaSyStaffID  NO  YES 
SyGroups  Non-Identifying  Zero or One to Zero or More  FK_SyCampus_TSMHoldGroupID_SyGroups_SyGroupsID      TSMHoldGroupID  NO  YES 
SyGroups  Non-Identifying  Zero or One to Zero or More  FK_SyCampus_TsmStudentGroupID_SyGroups_SyGroupsID      TSMStudentGroupID  NO  YES 
Child Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype  Not For Replication 
CmEventHistory_ro  Non-Identifying  One To Zero or More  CmEventHistory_roSessionSyCampusID_SyCampusSyCampusID        NO  YES 
FaSSCR  Non-Identifying  One To Zero or More  FaSSCR_SyCampusID_SyCampus_SyCampusID        NO  YES 
AdAttendArchiveQueue  Non-Identifying  One To Zero or More  FK_AdAttendArchiveQueue_SyCampusID_SyCampus_SyCampusID        NO  YES 
AdEnrollTermRelationshipException  Non-Identifying  One To Zero or More  FK_AdEnrollTermRelationshipException_SyCampusID_SyCampus_SyCampusID        NO  YES 
AdGainfulEmploymentConfiguration  Non-Identifying  One To Zero or More  FK_AdGainfulEmploymentConfigurationSyCampusId_SyCampusSyCampusId        NO  YES 
AdIPEDSDistEdCriteriaDetail  Non-Identifying  One To Zero or More  FK_AdIPEDSDistEdCriteriaDetail_CourseRegCampusID_SyCampus_SyCampusID        NO  YES 
AdIPEDSDistEdCriteriaDetail  Non-Identifying  One To Zero or More  FK_AdIPEDSDistEdCriteriaDetail_EnrollCampusID_SyCampus_SyCampusID        NO  YES 
AdRegistrationGroupTerm  Non-Identifying  One To Zero or More  FK_AdRegistrationGroupTerm_SyCampusId_SyCampus_SyCampusId        NO  YES 
AdSapQueue_Header  Non-Identifying  One To Zero or More  FK_AdSapQueue_Header_SyCampusID_SyCampus_SyCampusID        NO  YES 
AdStartTerm  Non-Identifying  One To Zero or More  FK_AdStartTerm_SyCampusID_SyCampus_SyCampusID        NO  YES 
AdStudentTransferHeader  Non-Identifying  One To Zero or More  FK_AdStudentTransferHeader_FromSyCampusID_SyCampus_SyCampusID        NO  YES 
AdStudentTransferHeader  Non-Identifying  One To Zero or More  FK_AdStudentTransferHeader_ToSyCampusID_SyCampus_SyCampusID        NO  YES 
AdTermCampusRelationship  Non-Identifying  One To Zero or More  FK_AdTermCampusRelationship_SyCampusID_SyCampus_SyCampusID        NO  NO 
AdTermOnLineRegistration  Identifying  One To Zero or More  FK_AdTermOnlineRegistration_SyCampusID_SyCampus_SyCampusID        NO  YES 
adTermRelationshipModifyLog  Non-Identifying  One To Zero or More  FK_adTermRelationshipModifyLog_SyCampusID_SyCampus_SyCampusID        NO  YES 
AmApplicant  Non-Identifying  One To Zero or More  FK_AmApplicant_SyCampusID_SyCampus_SyCampusID        NO  YES 
AmCourseRelDetail  Non-Identifying  One To Zero or More  FK_AmCourseRelDetail.SyCampusID_SyCampus.SyCampusID        NO  YES 
AmHighSchoolCourseRelationDetail  Non-Identifying  One To Zero or More  FK_AmHighSchoolCourseRelationDetailSyCampusID_SyCampusSyCampusID        NO  YES 
AmTestImportCollegeCodeByCampus  Non-Identifying  One To Zero or More  FK_AmTestImportCollegeCodeByCampusSyCampusID_SyCampusSyCampusID        NO  YES 
AmTestImportFileLayoutDetailAmTest  Non-Identifying  One To Zero or More  FK_AmTestImportFileLayoutDetailAmTestSyCampusID_SyCampusSyCampusID        NO  YES 
CmDocLocation  Non-Identifying  One To Zero or More  FK_CmDocLocation_SyCampusId_SyCampus_SyCampusId        NO  YES 
CmEvent  Non-Identifying  One To Zero or More  FK_CmEvent_SessionSyCampusID_SyCampus_SyCampusID        NO  YES 
CmEventQueue  Non-Identifying  One To Zero or More  FK_CmEventQueue_SyCampusID_SyCampus_SyCampusID        NO  YES 
CmGlobalDocumentCampus  Identifying  One To Zero or More  FK_CmGlobalDocumentCampus_SyCampusID_SyCampus_SyCampusID        NO  YES 
cmIncident  Non-Identifying  One To Zero or More  FK_CMIncident_SyCampusID_SyCampus_SyCampusID        NO  YES 
FaAwardLetterQueue  Non-Identifying  One To Zero or More  FK_FaAwardLetterQueue_SyCampusID_SyCampus_SyCampusID        NO  YES 
FaAwardYearFundSourceDisable  Non-Identifying  One To Zero or More  FK_FaAwardYearFundSourceDisable_SyCampusID_SyCampus_SyCampusID        NO  YES 
FaAwardYearMaxAmt  Non-Identifying  One To Zero or More  FK_FaAwardYearMaxAmt_SyCampusID_SyCampus_SyCampusID        NO  YES 
FaBatchExpImp  Non-Identifying  One To Zero or More  FK_FaBatchExpImp.SyCampusID_SyCampus.SyCampusID        NO  YES 
FaBatchPackage  Non-Identifying  One To Zero or More  FK_FaBatchPackage_SyCampusID_SyCampus_SyCampusID        NO  YES 
FaCampusVantageWorkStudyPayroll  Non-Identifying  One To Zero or More  FK_FaCampusVantageWorkStudyPayroll_SyCampusID_SyCampus_SyCampusId        NO  YES 
FaCashPlanConfigRelationship  Non-Identifying  One To Zero or More  FK_FaCashPlanConfigRelationshipSyCampusId_SyCampusSyCampusId        NO  YES 
FaCfpGrantOptionsConfig_Regulatory  Non-Identifying  One To Zero or More  FK_FaCfpGrantOptionsConfig_RegulatorySyCampusId_SyCampusSyCampusId        NO  YES 
FaDisbCriteriaCampusFundSource  Identifying  One To Zero or More  FK_FaDisbCriteriaCampusFundSource_SyCampusID_SyCampus_SyCampusID        NO  YES 
faExcusedAbsencePolicyDetail  Non-Identifying  One To Zero or More  FK_faExcusedAbsencePolicyDetail_SyCampusID_SyCampus_SyCampusID        NO  YES 
FaFundSourceAutoAwardRules  Non-Identifying  One To Zero or More  FK_FaFundSourceAutoAwardRules_SyCampusId_SyCampus_SyCampusId        NO  YES 
FaFundSourceBanks  Identifying  One To Zero or More  FK_FaFundSourceBanks_SyCampusID_SyCampus_SyCampusID        NO  YES 
FaFundSourcePriority  Non-Identifying  One To Zero or More  FK_FaFundSourcePriority_SyCampus        NO  YES 
FaGlAuthCampus  Non-Identifying  One To Zero or More  FK_FaGlAuthCampus_SyCampusID_SyCampus_SyCampusID        NO  YES 
FaMultiDisbSchedCampusCriteria  Non-Identifying  One To Zero or More  FK_FaMultiDisbSchedCampusCriteriaSyCampusID_SyCampusSyCampusID        NO  YES 
FaNoelLevitz  Non-Identifying  One To Zero or More  FK_FaNoelLevitzSyCampusId_SyCampusSyCampusId        NO  YES 
FaProgramVersionCOA  Non-Identifying  One To Zero or More  FK_FaProgramVersionCOA_SyCampusId_SyCampus_SyCampusId        NO  YES 
FaRepackageTriggerAssociation_Faa  Non-Identifying  One To Zero or More  FK_FaRepackageTriggerAssociation_FaaSyCampusId_SyCampusSyCampusId        NO  YES 
FaRepackageTriggerConfigAssociation_FAA  Non-Identifying  One To Zero or More  FK_FaRepackageTriggerConfigAssociation_SyCampusId_SyCampus_SyCampusID        NO  YES 
FaShoppingSheet  Non-Identifying  One To Zero or More  FK_FaShoppingSheet_SyCampus        NO  YES 
FaShoppingSheetBannerInfo  Non-Identifying  One To Zero or More  FK_FaShoppingSheetBannerInfoSyCampusId_SyCampusSyCampusId        NO  YES 
FaShoppingSheetCommentsConfig  Non-Identifying  One To Zero or More  FK_FaShoppingSheetCommentsConfigSyCampusId_SyCampusSyCampusId        NO  YES 
FaShoppingSheetCostsConfig  Non-Identifying  One To Zero or More  FK_FaShoppingSheetCostsConfigSyCampusId_SyCampusSyCampusId        NO  YES 
FaShoppingSheetLoanOptionsConfig  Non-Identifying  One To Zero or More  FK_FaShoppingSheetLoanOptionsConfigSyCampusId_SyCampusSyCampusId        NO  YES 
FaStudentAutoAwardLog  Non-Identifying  One To Zero or More  FK_FaStudentAutoAwardLog_SyCampusId_SyCampus_SyCampusId        NO  YES 
FaStudentMaster  Non-Identifying  One To Zero or More  FK_FaStudentMaster_SyCampusId_SyCampus_SyCampusId        NO  YES 
FaTsmMain  Non-Identifying  One To Zero or More  FK_FaTsmMainSyCampusID_AdSyCampusID_SyCampusID        NO  YES 
HsBuilding  Non-Identifying  One To Zero or More  FK_HsBuilding_syCampusID_syCampus_syCampusID        NO  YES 
HSRoomMateMatch  Non-Identifying  One To Zero or More  FK_HsRoomMateMatch_SyCampusID_SyCampus_SyCampusID        NO  YES 
HsStudentApplication  Non-Identifying  One To Zero or More  FK_HsStudentApplication_SyCampusID_SyCampus_SyCampusID        NO  YES 
PlElectronicEmployer  Non-Identifying  One To Zero or More  FK_PlElectronicEmployer_SyCampusID_SyCampus_SyCampusID        NO  YES 
SaACHConfigCampus  Non-Identifying  One To Zero or More  FK_SaACHConfigCampus_SyCampusID_SyCampus_SyCampusID        NO  YES 
SaAgeDaysConfiguration_Faa  Non-Identifying  One To Zero or More  FK_SaAgeDaysConfiguration_FaaSyCampusId_SyCampusSyCampusId        NO  YES 
SaAttendancePostPermission  Non-Identifying  One To Zero or More  FK_SaAttendancePostPermission_SyCampusID_Sycampus_Sycampusid        NO  YES 
SaAutoBillBatchDetail  Non-Identifying  One To Zero or More  FK_SaAutoBillBatchDetail_SyCampusID_SyCampus_SyCampusID        NO  YES 
SaAutoCharge  Non-Identifying  One To Zero or More  FK_SaAutoCharge_SyCampusID_SyCampus_SyCampusID        NO  YES 
SAAutoChargeProgramVersion  Non-Identifying  One To Zero or More  FK_SAAutoChargeProgramVersion_SyCampusId_SyCampus_SyCampusId        NO  YES 
SaBillingStatementBatchStudent  Non-Identifying  One To Zero or More  FK_SaBillingStatementBatchStudent_SyCampusId_SyCampus_SyCampusID        NO  YES 
SaCampusBillingResidencyTypeList  Non-Identifying  One To Zero or More  FK_SaCampusBillingResidencyTypeList_SyCampusId_SyCampus_SyCampusId        NO  NO 
SaCampusVantageErrorLog  Non-Identifying  One To Zero or More  FK_SaCampusVantageErrorLog_SyCampusID_SyCampus_SyCampusID        NO  YES 
SACreditCardCampus  Identifying  One To Zero or More  FK_SACreditCardCampus_SyCampus_SyCampus_SyCampusID        NO  YES 
SaDefaultIRPolicyConfiguration_FAA  Non-Identifying  One To Zero or More  FK_SaDefaultIRPolicyConfiguration_FAASyCampus_SyCampusId        NO  YES 
SaDynamicsErrorLog  Non-Identifying  One To Zero or More  FK_SaDynamicsErrorLog_SyCampusID_SyCampus_SyCampusID        NO  YES 
SaEnrollRevenueChildTerm  Non-Identifying  One To Zero or More  FK_SaEnrollRevenueChildTerm_SyCampusID_SyCampus_SyCampusID        NO  YES 
SaFundSourceOrder  Non-Identifying  One To Zero or More  FK_SaFundSourceOrder_SyCampusID_SyCampus_SyCampusID        NO  YES 
SaMonthEndProcess  Non-Identifying  One To Zero or More  FK_SaMonthEndProces_SyCampusID_SyCampus_SyCampusID        NO  YES 
SaNotificationConfiguration_Faa  Non-Identifying  One To Zero or More  FK_SaNotificationConfiguration_FaaSyCampusId_SyCampusSyCampusId        NO  YES 
SaPaymentApply  Non-Identifying  One To Zero or More  FK_SaPaymentApply_SyCampusId_SyCampus_SyCampusId        NO  YES 
SaPaymentApplyOrder  Non-Identifying  One To Zero or More  FK_SaPaymentApplyOrder_SyCampusId_SyCampus_SyCampusId        NO  YES 
SaPendingCharge  Non-Identifying  One To Zero or More  FK_saPendingCharge.SyCampusID_SyCampus.SyCampusID        NO  YES 
SaPendingChargeCourseAmount  Non-Identifying  One To Zero or More  FK_SaPendingChargeCourseAmount_SyCampusID_SyCampus_SyCampusID        NO  YES 
SaPendingChargeRecalcLog  Non-Identifying  One To Zero or More  FK_SaPendingChargeRecalcLog_SyCampusId_SyCampus_SyCampusID        NO  YES 
SaPWDNotificationConfiguration  Non-Identifying  One To Zero or More  FK_SaPWDNotificationConfigurationSyCampusID_SyCampusSyCampusID        NO  YES 
SaPWDRoutingTemplateRelationship  Non-Identifying  One To Zero or More  FK_SaPWDRoutingTemplateRelationshipSyCampusID_SyCampusSyCampusID        NO  YES 
SaRefundCalculationAgeDaysConfiguration  Non-Identifying  One To Zero or More  FK_SaRefundCalculationAgeDaysConfigurationSyCampusId_SyCampusSyCampusId        NO  YES 
SaRefundCalculationConfiguration  Non-Identifying  One To Zero or More  FK_SaRefundCalculationConfigurationSyCampusID_SyCampusSyCampusID        NO  YES 
SaStudSubsidiaryTrans  Non-Identifying  One To Zero or More  Fk_SaStudSubsidiaryTrans_SyCampusID_SyCampus_SyCampusID        NO  YES 
SaSubsidiaryCampus  Non-Identifying  One To Zero or More  FK_SaSubsidiaryCampus_SyCampusID_SyCampus_SyCampusID        NO  YES 
SaTransCourseAmount  Non-Identifying  One To Zero or More  FK_SaTransCourseAmount_SyCampusID_SyCampus_SyCampusID        NO  YES 
SaTuitionDiscountOrder  Non-Identifying  One To Zero or More  FK_SaTuitionDiscountOrderSyCampusID_SyCampusSyCampusID        NO  YES 
SsLocation  Non-Identifying  One To Zero or More  FK_SsLocation_SyCampusID_SyCampus_SyCampusID        NO  YES 
SyAdvancedSearchSavedCriteria  Non-Identifying  One To Zero or More  FK_SyAdvancedSearchSavedCriteria_SyCampusID_SyCampus_SyCampusID        NO  YES 
SyAdvisorCampusDefaults  Identifying  One To Zero or More  FK_SyAdvisorCampusDefaults_SyCampusID_SyCampus_SyCampusID        NO  YES 
SyAutomatedProcessActivation  Non-Identifying  One To Zero or More  FK_SyAutomatedProcessActivationSyCampusID_SyCampusSyCampusID        NO  YES 
SyBatchRegulatory  Non-Identifying  One To Zero or More  FK_SyBatchRegulatorySyCampusId_SyCampus_SyCampusId        NO  YES 
SyCampusADPaths  Non-Identifying  One To Zero or More  FK_SyCampusADPaths_SyCampusID_SyCampus_SyCampusID        NO  YES 
SyCampusAutoAddCourseSection  Non-Identifying  One To Zero or More  FK_SyCampusAutoAddCourseSection_SyCampusId_SyCampus_SyCampusId        NO  YES 
SyCampusAwardingConfig  Identifying  One To Zero or More  FK_SyCampusAwardingConfig_SyCampus        NO  YES 
SyCampusCrossRegGroup  Non-Identifying  One To Zero or More  FK_SyCampusCrossRegGroup_SyCampusID_SyCampus_SyCampusID        NO  YES 
SyCampusCrossRegGroup  Non-Identifying  One To Zero or More  FK_SyCampusCrossRegGroup_SyCampusShareID_SyCampus_SyCampusID        NO  YES 
SyCampusDetails  Identifying  One To Zero or More  FK_SyCampusDetails_SyCampusID_SyCampus_SyCampusID        NO  YES 
SyCampusECodes  Identifying  One To Zero or More  FK_SyCampusECodes_SyCampusID_SyCampus_SyCampusID        NO  YES 
SyCampusEmails  Non-Identifying  One To Zero or More  FK_SyCampusEmails_SyCampusID_SyCampus_SyCampusID        NO  YES 
syCampusExternalMap  Non-Identifying  One To Zero or More  FK_syCampusExternalMapsyCampusId_syCampussyCampusId        NO  YES 
SyCampusLmsVendor  Non-Identifying  One To Zero or More  Fk_SyCampusLmsVendor_SyCampusID_SyCampus_SyCampusID        NO  YES 
SyCampusTransferCreditStatus  Non-Identifying  One To Zero or More  FK_SyCampusTransferCreditStatus_SyCampusID_SyCampus_SyCampusID        NO  YES 
SyCODDirectLoanEntity  Non-Identifying  One To Zero or More  FK_SyCODDirectLoanEntity_SyCampusID_SyCampus_SyCampusID        NO  YES 
SyExceptionMessages  Non-Identifying  One To Zero or More  FK_SyExceptionMessages.SyCampusID_SyCampus.SyCampusID        NO  YES 
syIMSConfiguration  Non-Identifying  One To Zero or More  FK_syIMSConfiguration_syCampusID_SyCampus_SyCampusID        NO  YES 
syIMSExtension  Non-Identifying  One To Zero or More  FK_syIMSExtension_syCampusID_SyCampus_SyCampusID        NO  YES 
syIMSExtensionStructure  Non-Identifying  One To Zero or More  FK_syIMSExtensionStructure_syCampusID_SyCampus_SyCampusID        NO  YES 
SyServiceException  Non-Identifying  One To Zero or More  FK_SyServiceException_SyCampus_SyCampusId        NO  YES 
SyServiceExceptionCampusProperty  Non-Identifying  One To Zero or More  FK_SyServiceExceptionCampusProperty_SyCampusId_SyCampus_SyCampusId        NO  YES 
SyServiceExceptionDocumentReview  Non-Identifying  One To Zero or More  FK_SyServiceExceptionDocumentReviewSyCampusID_SyCampusSyCampusID        NO  YES 
SyServiceExceptionOverrideTemplateRelationship  Non-Identifying  One To Zero or More  FK_SyServiceExceptionOverrideTemplateRelationshipSyCampusId_SyCampusSyCampusId        NO  YES 
SyServiceExceptionQueue  Non-Identifying  One To Zero or More  FK_SyServiceExceptionQueueSycampusID_SyCampusSyCampusID        NO  YES 
SyServiceExceptionResolutionAutoGroupCampus  Non-Identifying  One To Zero or More  FK_SyServiceExceptionResolutionAutoGroupCampusSyCampusId_SyCampusId        NO  YES 
SyServiceExceptionRoutingDocumentRelationship  Non-Identifying  One To Zero or More  Fk_SyServiceExceptionRoutingDocumentRelationship_SyCampus        NO  YES 
SyServiceMessageSourceRecord  Non-Identifying  One To Zero or More  FK_SyServiceMessageSourceRecordSyCampusId_SyCampusSyCampusId        NO  YES 
SyServiceProcessSubscriptionDetail  Non-Identifying  One To Zero or More  FK_SyServiceProcessSubscriptionDetailSyCampusId_SyCampusSyCampusId        NO  YES 
SyServiceRecipientMailboxCommonLineRelationship  Non-Identifying  One To Zero or More  FK_SyServiceRecipientMailboxCommonLineRelationshipSyCampusId_SyCampusSyCampusId        NO  YES 
SyServiceRecipientMailboxProcessRelationship  Non-Identifying  One To Zero or More  FK_SyServiceRecipientMailboxProcessRelationshipSyCampusId_SyCampusSyCampusId        NO  YES 
SyServiceSTARExceptionQueue  Non-Identifying  One To Zero or More  FK_SyServiceSTARExceptionQueueSyCampusId_SyCampusSyCampusId        NO  YES 
SyServiceSubscriptionExceptionRoutingRelationship  Non-Identifying  One To Zero or More  FK_SyServiceSubscriptionExceptionRoutingRelationshipSyCampusId_SyCampusSyCampusId        NO  YES 
SySEVISCampus  Non-Identifying  One To Zero or More  FK_SySEVISCampus_SyCampusID_SyCampus_SyCampusID        NO  YES 
SySEVISSiteOfActivity  Non-Identifying  One To Zero or More  FK_SySEVISSiteOfActivity_SyCampusID_SyCampus_SyCampusID        NO  YES 
SyStateReportCampusInfo  Non-Identifying  One To Zero or More  FK_SyStateReportCampusInfo_SyCampusID_SyCampus_SyCampusID        NO  YES 
SyStudentInquiry  Non-Identifying  One To Zero or More  FK_SyStudentInquiry_SyCampusID_SyCampus_SyCampusID        NO  YES 
SyUserFormLog  Non-Identifying  One To Zero or More  FK_SyUserFormLog_DefaultSyCampusID_SyCampus_SyCampusID        NO  YES 
wpCampusSettings  Non-Identifying  One To Zero or More  Fk_wpCampusSettings_SyCampusID_SyCampus_SyCampusID        NO  YES 

SyCampus Check Constraints 
Check Constraint Name  CheckConstraint